/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.bis.logic;

import com.dao.ConnectionDB;
import com.microsoft.sqlserver.jdbc.SQLServerParameterMetaData;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import java.util.HashMap;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author NguyenVan
 */
public class DatabaseInteraction {

    public DatabaseInteraction() {
    }

    ConnectionDB connectdb = new ConnectionDB();
    private Connection connect;
    private PreparedStatement pst;
    private CallableStatement cst;
    private ResultSet rs;

    public ResultSet getDataWithStoreNoParameter(String store)  {
        try {
            
            connect = connectdb.ConnectionDatabase();
            cst=connect.prepareCall(store);
            rs=cst.executeQuery();
            
            return rs;
        } catch (SQLException ex) {
            Logger.getLogger(DatabaseInteraction.class.getName()).log(Level.SEVERE, null, ex);
        }
        return null;
    }
    
    //Create getDataStodeParam

}
